package com.aaa.order.dao;

import com.aaa.entity.Order;
import com.aaa.vo.Result;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author 崔灿
 * @Date 2023/03/02 09:25
 * @ClassName OrderEchartDao
 * @Description
 * @Version 1.0
 */


public interface OrderEchartDao extends BaseMapper<Order> {
    @Select("SELECT sum(total_price) totalPrices, start_time,end_time FROM `mbs_order` WHERE state=4 GROUP BY start_time")
    List<Order> selectAll();
}
